Overview

Brought to you by YData

Dataset statistics

Number of variables	25
Number of observations	36992
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	7.1 MiB
Average record size in memory	200.0 B

Variable types

Text	5
Numeric	6
Categorical	9
DateTime	2
Boolean	3

Alerts

`churn_risk_score` is highly overall correlated with `points_in_wallet`	High correlation
`complaint_status` is highly overall correlated with `past_complaint`	High correlation
`offer_application_preference` is highly overall correlated with `used_special_discount`	High correlation
`past_complaint` is highly overall correlated with `complaint_status`	High correlation
`points_in_wallet` is highly overall correlated with `churn_risk_score`	High correlation
`used_special_discount` is highly overall correlated with `offer_application_preference`	High correlation
`customer_id` has unique values	Unique
`Name` has unique values	Unique
`security_no` has unique values	Unique

Reproduction

Analysis started	2025-10-25 19:07:59.225478
Analysis finished	2025-10-25 19:08:34.364199
Duration	35.14 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

customer_id
Text

Unique

Distinct	36992
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Length

Max length	36
Median length	36
Mean length	35.271734
Min length	20

Characters and Unicode

Total characters	1304772
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	36992 ?
Unique (%)	100.0%

Sample

1st row	fffe4300490044003600300030003800
2nd row	fffe43004900440032003100300035003700
3rd row	fffe4300490044003100390032003600
4th row	fffe43004900440036003000330031003600
5th row	fffe43004900440031003900350030003600

Value	Count	Frequency (%)
fffe4300490044003600300030003800	1	< 0.1%
fffe43004900440033003700330038003900	1	< 0.1%
fffe43004900440032003200350033003200	1	< 0.1%
fffe43004900440033003300330032003200	1	< 0.1%
fffe4300490044003100390032003600	1	< 0.1%
fffe43004900440036003000330031003600	1	< 0.1%
fffe43004900440031003900350030003600	1	< 0.1%
fffe43004900440036003300320035003300	1	< 0.1%
fffe43004900440031003100360037003900	1	< 0.1%
fffe4300490044003800300035003800	1	< 0.1%
Other values (36982)	36982	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	592862	45.4%
3	236016	18.1%
4	168252	12.9%
f	110976	8.5%
9	51579	4.0%
e	36992	2.8%
1	20900	1.6%
2	20831	1.6%
5	20484	1.6%
6	16674	1.3%
Other values (2)	29206	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1156804	88.7%
Lowercase Letter	147968	11.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	592862	51.2%
3	236016	20.4%
4	168252	14.5%
9	51579	4.5%
1	20900	1.8%
2	20831	1.8%
5	20484	1.8%
6	16674	1.4%
8	14641	1.3%
7	14565	1.3%

Lowercase Letter

Value	Count	Frequency (%)
f	110976	75.0%
e	36992	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1156804	88.7%
Latin	147968	11.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	592862	51.2%
3	236016	20.4%
4	168252	14.5%
9	51579	4.5%
1	20900	1.8%
2	20831	1.8%
5	20484	1.8%
6	16674	1.4%
8	14641	1.3%
7	14565	1.3%

Latin

Value	Count	Frequency (%)
f	110976	75.0%
e	36992	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1304772	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	592862	45.4%
3	236016	18.1%
4	168252	12.9%
f	110976	8.5%
9	51579	4.0%
e	36992	2.8%
1	20900	1.6%
2	20831	1.6%
5	20484	1.6%
6	16674	1.3%
Other values (2)	29206	2.2%

Name
Text

Unique

Distinct	36992
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Length

Max length	24
Median length	21
Mean length	13.522924
Min length	6

Characters and Unicode

Total characters	500240
Distinct characters	53
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	36992 ?
Unique (%)	100.0%

Sample

1st row	Pattie Morrisey
2nd row	Traci Peery
3rd row	Merideth Mcmeen
4th row	Eufemia Cardwell
5th row	Meghan Kosak

Value	Count	Frequency (%)
sidney	137	0.2%
gilda	126	0.2%
selena	123	0.2%
noe	123	0.2%
lesli	121	0.2%
karri	121	0.2%
marietta	120	0.2%
kenny	120	0.2%
earlie	119	0.2%
dean	119	0.2%
Other values (2511)	72755	98.3%

Most occurring characters

Value	Count	Frequency (%)
e	54599	10.9%
a	50451	10.1%
	36992	7.4%
n	36286	7.3%
r	34094	6.8%
i	33029	6.6%
l	29840	6.0%
o	24859	5.0%
t	17988	3.6%
s	15985	3.2%
Other values (43)	166117	33.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	389264	77.8%
Uppercase Letter	73984	14.8%
Space Separator	36992	7.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	54599	14.0%
a	50451	13.0%
n	36286	9.3%
r	34094	8.8%
i	33029	8.5%
l	29840	7.7%
o	24859	6.4%
t	17988	4.6%
s	15985	4.1%
d	11744	3.0%
Other values (16)	80389	20.7%

Uppercase Letter

Value	Count	Frequency (%)
S	7104	9.6%
M	6774	9.2%
L	5702	7.7%
B	4974	6.7%
A	4941	6.7%
C	4690	6.3%
D	3984	5.4%
K	3882	5.2%
G	3507	4.7%
R	3447	4.7%
Other values (16)	24979	33.8%

Space Separator

Value	Count	Frequency (%)
	36992	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	463248	92.6%
Common	36992	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	54599	11.8%
a	50451	10.9%
n	36286	7.8%
r	34094	7.4%
i	33029	7.1%
l	29840	6.4%
o	24859	5.4%
t	17988	3.9%
s	15985	3.5%
d	11744	2.5%
Other values (42)	154373	33.3%

Common

Value	Count	Frequency (%)
	36992	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	500240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	54599	10.9%
a	50451	10.1%
	36992	7.4%
n	36286	7.3%
r	34094	6.8%
i	33029	6.6%
l	29840	6.0%
o	24859	5.0%
t	17988	3.6%
s	15985	3.2%
Other values (43)	166117	33.2%

age
Real number (ℝ)

Distinct	55
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.118161

Minimum	10
Maximum	64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	289.1 KiB

Quantile statistics

Minimum	10
5-th percentile	12
Q1	23
median	37
Q3	51
95-th percentile	62
Maximum	64
Range	54
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	15.867412
Coefficient of variation (CV)	0.4274838
Kurtosis	-1.1987327
Mean	37.118161
Median Absolute Deviation (MAD)	14
Skewness	-0.0073193193
Sum	1373075
Variance	251.77477
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	720	1.9%
42	716	1.9%
16	716	1.9%
38	714	1.9%
30	711	1.9%
61	709	1.9%
60	704	1.9%
57	704	1.9%
41	699	1.9%
59	696	1.9%
Other values (45)	29903	80.8%

Value	Count	Frequency (%)
10	670	1.8%
11	654	1.8%
12	661	1.8%
13	654	1.8%
14	670	1.8%
15	649	1.8%
16	716	1.9%
17	683	1.8%
18	629	1.7%
19	660	1.8%

Value	Count	Frequency (%)
64	672	1.8%
63	656	1.8%
62	677	1.8%
61	709	1.9%
60	704	1.9%
59	696	1.9%
58	678	1.8%
57	704	1.9%
56	682	1.8%
55	695	1.9%

gender
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

F	18490
M	18443
Unknown	59

Length

Max length	7
Median length	1
Mean length	1.0095696
Min length	1

Characters and Unicode

Total characters	37346
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	F
2nd row	F
3rd row	F
4th row	M
5th row	F

Common Values

Value	Count	Frequency (%)
F	18490	50.0%
M	18443	49.9%
Unknown	59	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
f	18490	50.0%
m	18443	49.9%
unknown	59	0.2%

Most occurring characters

Value	Count	Frequency (%)
F	18490	49.5%
M	18443	49.4%
n	177	0.5%
U	59	0.2%
k	59	0.2%
o	59	0.2%
w	59	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	36992	99.1%
Lowercase Letter	354	0.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	177	50.0%
k	59	16.7%
o	59	16.7%
w	59	16.7%

Uppercase Letter

Value	Count	Frequency (%)
F	18490	50.0%
M	18443	49.9%
U	59	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	37346	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	18490	49.5%
M	18443	49.4%
n	177	0.5%
U	59	0.2%
k	59	0.2%
o	59	0.2%
w	59	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37346	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	18490	49.5%
M	18443	49.4%
n	177	0.5%
U	59	0.2%
k	59	0.2%
o	59	0.2%
w	59	0.2%

security_no
Text

Unique

Distinct	36992
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	258944
Distinct characters	36
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	36992 ?
Unique (%)	100.0%

Sample

1st row	XW0DQ7H
2nd row	5K0N3X1
3rd row	1F2TCL3
4th row	VJGJ33N
5th row	SVZXCWB

Value	Count	Frequency (%)
xw0dq7h	1	< 0.1%
6rz86vw	1	< 0.1%
c229qzz	1	< 0.1%
0481qnq	1	< 0.1%
1f2tcl3	1	< 0.1%
vjgj33n	1	< 0.1%
svzxcwb	1	< 0.1%
psg1lgf	1	< 0.1%
r3cx1ea	1	< 0.1%
4uj1551	1	< 0.1%
Other values (36982)	36982	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
G	7410	2.9%
D	7391	2.9%
H	7346	2.8%
Z	7307	2.8%
A	7294	2.8%
T	7270	2.8%
F	7262	2.8%
R	7249	2.8%
M	7248	2.8%
5	7244	2.8%
Other values (26)	185923	71.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	187293	72.3%
Decimal Number	71651	27.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	7410	4.0%
D	7391	3.9%
H	7346	3.9%
Z	7307	3.9%
A	7294	3.9%
T	7270	3.9%
F	7262	3.9%
R	7249	3.9%
M	7248	3.9%
O	7229	3.9%
Other values (16)	114287	61.0%

Decimal Number

Value	Count	Frequency (%)
5	7244	10.1%
2	7236	10.1%
7	7220	10.1%
8	7213	10.1%
9	7171	10.0%
4	7171	10.0%
1	7163	10.0%
0	7157	10.0%
3	7043	9.8%
6	7033	9.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	187293	72.3%
Common	71651	27.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	7410	4.0%
D	7391	3.9%
H	7346	3.9%
Z	7307	3.9%
A	7294	3.9%
T	7270	3.9%
F	7262	3.9%
R	7249	3.9%
M	7248	3.9%
O	7229	3.9%
Other values (16)	114287	61.0%

Common

Value	Count	Frequency (%)
5	7244	10.1%
2	7236	10.1%
7	7220	10.1%
8	7213	10.1%
9	7171	10.0%
4	7171	10.0%
1	7163	10.0%
0	7157	10.0%
3	7043	9.8%
6	7033	9.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	258944	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	7410	2.9%
D	7391	2.9%
H	7346	2.8%
Z	7307	2.8%
A	7294	2.8%
T	7270	2.8%
F	7262	2.8%
R	7249	2.8%
M	7248	2.8%
5	7244	2.8%
Other values (26)	185923	71.8%

region_category
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Town	19556
City	12737
Village	4699

Length

Max length	7
Median length	4
Mean length	4.3810824
Min length	4

Characters and Unicode

Total characters	162065
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Village
2nd row	City
3rd row	Town
4th row	City
5th row	City

Common Values

Value	Count	Frequency (%)
Town	19556	52.9%
City	12737	34.4%
Village	4699	12.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
town	19556	52.9%
city	12737	34.4%
village	4699	12.7%

Most occurring characters

Value	Count	Frequency (%)
T	19556	12.1%
o	19556	12.1%
w	19556	12.1%
n	19556	12.1%
i	17436	10.8%
C	12737	7.9%
t	12737	7.9%
y	12737	7.9%
l	9398	5.8%
V	4699	2.9%
Other values (3)	14097	8.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	125073	77.2%
Uppercase Letter	36992	22.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	19556	15.6%
w	19556	15.6%
n	19556	15.6%
i	17436	13.9%
t	12737	10.2%
y	12737	10.2%
l	9398	7.5%
a	4699	3.8%
g	4699	3.8%
e	4699	3.8%

Uppercase Letter

Value	Count	Frequency (%)
T	19556	52.9%
C	12737	34.4%
V	4699	12.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	162065	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	19556	12.1%
o	19556	12.1%
w	19556	12.1%
n	19556	12.1%
i	17436	10.8%
C	12737	7.9%
t	12737	7.9%
y	12737	7.9%
l	9398	5.8%
V	4699	2.9%
Other values (3)	14097	8.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	162065	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	19556	12.1%
o	19556	12.1%
w	19556	12.1%
n	19556	12.1%
i	17436	10.8%
C	12737	7.9%
t	12737	7.9%
y	12737	7.9%
l	9398	5.8%
V	4699	2.9%
Other values (3)	14097	8.7%

membership_category
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Basic Membership	7724
No Membership	7692
Gold Membership	6795
Silver Membership	5988
Premium Membership	4455

Length

Max length	19
Median length	17
Mean length	15.947043
Min length	13

Characters and Unicode

Total characters	589913
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Platinum Membership
2nd row	Premium Membership
3rd row	No Membership
4th row	No Membership
5th row	No Membership

Common Values

Value	Count	Frequency (%)
Basic Membership	7724	20.9%
No Membership	7692	20.8%
Gold Membership	6795	18.4%
Silver Membership	5988	16.2%
Premium Membership	4455	12.0%
Platinum Membership	4338	11.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
membership	36992	50.0%
basic	7724	10.4%
no	7692	10.4%
gold	6795	9.2%
silver	5988	8.1%
premium	4455	6.0%
platinum	4338	5.9%

Most occurring characters

Value	Count	Frequency (%)
e	84427	14.3%
i	59497	10.1%
m	50240	8.5%
r	47435	8.0%
s	44716	7.6%
p	36992	6.3%
	36992	6.3%
M	36992	6.3%
b	36992	6.3%
h	36992	6.3%
Other values (14)	118638	20.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	478937	81.2%
Uppercase Letter	73984	12.5%
Space Separator	36992	6.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	84427	17.6%
i	59497	12.4%
m	50240	10.5%
r	47435	9.9%
s	44716	9.3%
p	36992	7.7%
b	36992	7.7%
h	36992	7.7%
l	17121	3.6%
o	14487	3.0%
Other values (7)	50038	10.4%

Uppercase Letter

Value	Count	Frequency (%)
M	36992	50.0%
P	8793	11.9%
B	7724	10.4%
N	7692	10.4%
G	6795	9.2%
S	5988	8.1%

Space Separator

Value	Count	Frequency (%)
	36992	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	552921	93.7%
Common	36992	6.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	84427	15.3%
i	59497	10.8%
m	50240	9.1%
r	47435	8.6%
s	44716	8.1%
p	36992	6.7%
M	36992	6.7%
b	36992	6.7%
h	36992	6.7%
l	17121	3.1%
Other values (13)	101517	18.4%

Common

Value	Count	Frequency (%)
	36992	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	589913	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	84427	14.3%
i	59497	10.1%
m	50240	8.5%
r	47435	8.0%
s	44716	7.6%
p	36992	6.3%
	36992	6.3%
M	36992	6.3%
b	36992	6.3%
h	36992	6.3%
Other values (14)	118638	20.1%

joining_date
Date

Distinct	1096
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Minimum	2015-01-01 00:00:00
Maximum	2017-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

joined_through_referral
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

No	15839
Yes	15715
?	5438

Length

Max length	3
Median length	2
Mean length	2.2778168
Min length	1

Characters and Unicode

Total characters	84261
Distinct characters	6
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	?
3rd row	Yes
4th row	Yes
5th row	No

Common Values

Value	Count	Frequency (%)
No	15839	42.8%
Yes	15715	42.5%
?	5438	14.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	15839	42.8%
yes	15715	42.5%
	5438	14.7%

Most occurring characters

Value	Count	Frequency (%)
N	15839	18.8%
o	15839	18.8%
Y	15715	18.7%
e	15715	18.7%
s	15715	18.7%
?	5438	6.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	47269	56.1%
Uppercase Letter	31554	37.4%
Other Punctuation	5438	6.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	15839	33.5%
e	15715	33.2%
s	15715	33.2%

Uppercase Letter

Value	Count	Frequency (%)
N	15839	50.2%
Y	15715	49.8%

Other Punctuation

Value	Count	Frequency (%)
?	5438	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	78823	93.5%
Common	5438	6.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	15839	20.1%
o	15839	20.1%
Y	15715	19.9%
e	15715	19.9%
s	15715	19.9%

Common

Value	Count	Frequency (%)
?	5438	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84261	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	15839	18.8%
o	15839	18.8%
Y	15715	18.7%
e	15715	18.7%
s	15715	18.7%
?	5438	6.5%

referral_id
Text

Distinct	11359
Distinct (%)	30.7%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Length

Max length	11
Median length	8
Mean length	7.9114944
Min length	4

Characters and Unicode

Total characters	292662
Distinct characters	22
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6801 ?
Unique (%)	18.4%

Sample

1st row	xxxxxxxx
2nd row	CID21329
3rd row	CID12313
4th row	CID3793
5th row	xxxxxxxx

Value	Count	Frequency (%)
xxxxxxxx	17846	48.2%
cid43705	12	< 0.1%
cid3979	11	< 0.1%
cid49601	10	< 0.1%
cid15792	9	< 0.1%
cid23978	9	< 0.1%
cid40797	9	< 0.1%
cid49598	9	< 0.1%
cid62015	9	< 0.1%
cid43428	8	< 0.1%
Other values (11350)	19065	51.5%

Most occurring characters

Value	Count	Frequency (%)
x	142768	48.8%
C	19141	6.5%
I	19141	6.5%
D	19141	6.5%
1	10838	3.7%
2	10822	3.7%
3	10766	3.7%
5	10537	3.6%
4	10515	3.6%
6	8761	3.0%
Other values (12)	30232	10.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	142813	48.8%
Decimal Number	92416	31.6%
Uppercase Letter	57428	19.6%
Space Separator	5	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	10838	11.7%
2	10822	11.7%
3	10766	11.6%
5	10537	11.4%
4	10515	11.4%
6	8761	9.5%
0	7591	8.2%
8	7559	8.2%
9	7550	8.2%
7	7477	8.1%

Lowercase Letter

Value	Count	Frequency (%)
x	142768	> 99.9%
r	15	< 0.1%
e	10	< 0.1%
o	5	< 0.1%
f	5	< 0.1%
a	5	< 0.1%
l	5	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
C	19141	33.3%
I	19141	33.3%
D	19141	33.3%
N	5	< 0.1%

Space Separator

Value	Count	Frequency (%)
	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	200241	68.4%
Common	92421	31.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
x	142768	71.3%
C	19141	9.6%
I	19141	9.6%
D	19141	9.6%
r	15	< 0.1%
e	10	< 0.1%
N	5	< 0.1%
o	5	< 0.1%
f	5	< 0.1%
a	5	< 0.1%

Common

Value	Count	Frequency (%)
1	10838	11.7%
2	10822	11.7%
3	10766	11.6%
5	10537	11.4%
4	10515	11.4%
6	8761	9.5%
0	7591	8.2%
8	7559	8.2%
9	7550	8.2%
7	7477	8.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	292662	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
x	142768	48.8%
C	19141	6.5%
I	19141	6.5%
D	19141	6.5%
1	10838	3.7%
2	10822	3.7%
3	10766	3.7%
5	10537	3.6%
4	10515	3.6%
6	8761	3.0%
Other values (12)	30232	10.3%

preferred_offer_types
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Gift Vouchers/Coupons	12637
Credit/Debit Card Offers	12274
Without Offers	12081

Length

Max length	24
Median length	21
Mean length	19.709316
Min length	14

Characters and Unicode

Total characters	729087
Distinct characters	23
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Gift Vouchers/Coupons
2nd row	Gift Vouchers/Coupons
3rd row	Gift Vouchers/Coupons
4th row	Gift Vouchers/Coupons
5th row	Credit/Debit Card Offers

Common Values

Value	Count	Frequency (%)
Gift Vouchers/Coupons	12637	34.2%
Credit/Debit Card Offers	12274	33.2%
Without Offers	12081	32.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
offers	24355	28.2%
gift	12637	14.7%
vouchers/coupons	12637	14.7%
credit/debit	12274	14.2%
card	12274	14.2%
without	12081	14.0%

Most occurring characters

Value	Count	Frequency (%)
r	61540	8.4%
e	61540	8.4%
f	61347	8.4%
t	61347	8.4%
o	49992	6.9%
s	49629	6.8%
	49266	6.8%
i	49266	6.8%
u	37355	5.1%
C	37185	5.1%
Other values (13)	210620	28.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	543741	74.6%
Uppercase Letter	111169	15.2%
Space Separator	49266	6.8%
Other Punctuation	24911	3.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	61540	11.3%
e	61540	11.3%
f	61347	11.3%
t	61347	11.3%
o	49992	9.2%
s	49629	9.1%
i	49266	9.1%
u	37355	6.9%
h	24718	4.5%
d	24548	4.5%
Other values (5)	62459	11.5%

Uppercase Letter

Value	Count	Frequency (%)
C	37185	33.4%
O	24355	21.9%
G	12637	11.4%
V	12637	11.4%
D	12274	11.0%
W	12081	10.9%

Space Separator

Value	Count	Frequency (%)
	49266	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	24911	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	654910	89.8%
Common	74177	10.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	61540	9.4%
e	61540	9.4%
f	61347	9.4%
t	61347	9.4%
o	49992	7.6%
s	49629	7.6%
i	49266	7.5%
u	37355	5.7%
C	37185	5.7%
h	24718	3.8%
Other values (11)	160991	24.6%

Common

Value	Count	Frequency (%)
	49266	66.4%
/	24911	33.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	729087	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	61540	8.4%
e	61540	8.4%
f	61347	8.4%
t	61347	8.4%
o	49992	6.9%
s	49629	6.8%
	49266	6.8%
i	49266	6.8%
u	37355	5.1%
C	37185	5.1%
Other values (13)	210620	28.9%

medium_of_operation
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Desktop	13913
Smartphone	13876
?	5393
Both	3810

Length

Max length	10
Median length	7
Mean length	6.941609
Min length	1

Characters and Unicode

Total characters	256784
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	?
2nd row	Desktop
3rd row	Desktop
4th row	Desktop
5th row	Smartphone

Common Values

Value	Count	Frequency (%)
Desktop	13913	37.6%
Smartphone	13876	37.5%
?	5393	14.6%
Both	3810	10.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
desktop	13913	37.6%
smartphone	13876	37.5%
	5393	14.6%
both	3810	10.3%

Most occurring characters

Value	Count	Frequency (%)
t	31599	12.3%
o	31599	12.3%
e	27789	10.8%
p	27789	10.8%
h	17686	6.9%
D	13913	5.4%
s	13913	5.4%
k	13913	5.4%
S	13876	5.4%
m	13876	5.4%
Other values (5)	50831	19.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	219792	85.6%
Uppercase Letter	31599	12.3%
Other Punctuation	5393	2.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	31599	14.4%
o	31599	14.4%
e	27789	12.6%
p	27789	12.6%
h	17686	8.0%
s	13913	6.3%
k	13913	6.3%
m	13876	6.3%
a	13876	6.3%
r	13876	6.3%

Uppercase Letter

Value	Count	Frequency (%)
D	13913	44.0%
S	13876	43.9%
B	3810	12.1%

Other Punctuation

Value	Count	Frequency (%)
?	5393	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	251391	97.9%
Common	5393	2.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	31599	12.6%
o	31599	12.6%
e	27789	11.1%
p	27789	11.1%
h	17686	7.0%
D	13913	5.5%
s	13913	5.5%
k	13913	5.5%
S	13876	5.5%
m	13876	5.5%
Other values (4)	45438	18.1%

Common

Value	Count	Frequency (%)
?	5393	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	256784	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	31599	12.3%
o	31599	12.3%
e	27789	10.8%
p	27789	10.8%
h	17686	6.9%
D	13913	5.4%
s	13913	5.4%
k	13913	5.4%
S	13876	5.4%
m	13876	5.4%
Other values (5)	50831	19.8%

internet_option
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Wi-Fi	12413
Mobile_Data	12343
Fiber_Optic	12236

Length

Max length	11
Median length	11
Mean length	8.9866458
Min length	5

Characters and Unicode

Total characters	332434
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Wi-Fi
2nd row	Mobile_Data
3rd row	Wi-Fi
4th row	Mobile_Data
5th row	Mobile_Data

Common Values

Value	Count	Frequency (%)
Wi-Fi	12413	33.6%
Mobile_Data	12343	33.4%
Fiber_Optic	12236	33.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wi-fi	12413	33.6%
mobile_data	12343	33.4%
fiber_optic	12236	33.1%

Most occurring characters

Value	Count	Frequency (%)
i	61641	18.5%
a	24686	7.4%
F	24649	7.4%
e	24579	7.4%
t	24579	7.4%
_	24579	7.4%
b	24579	7.4%
W	12413	3.7%
-	12413	3.7%
l	12343	3.7%
Other values (7)	85973	25.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	221458	66.6%
Uppercase Letter	73984	22.3%
Connector Punctuation	24579	7.4%
Dash Punctuation	12413	3.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	61641	27.8%
a	24686	11.1%
e	24579	11.1%
t	24579	11.1%
b	24579	11.1%
l	12343	5.6%
o	12343	5.6%
r	12236	5.5%
p	12236	5.5%
c	12236	5.5%

Uppercase Letter

Value	Count	Frequency (%)
F	24649	33.3%
W	12413	16.8%
D	12343	16.7%
M	12343	16.7%
O	12236	16.5%

Connector Punctuation

Value	Count	Frequency (%)
_	24579	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	12413	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	295442	88.9%
Common	36992	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	61641	20.9%
a	24686	8.4%
F	24649	8.3%
e	24579	8.3%
t	24579	8.3%
b	24579	8.3%
W	12413	4.2%
l	12343	4.2%
o	12343	4.2%
D	12343	4.2%
Other values (5)	61287	20.7%

Common

Value	Count	Frequency (%)
_	24579	66.4%
-	12413	33.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	332434	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	61641	18.5%
a	24686	7.4%
F	24649	7.4%
e	24579	7.4%
t	24579	7.4%
_	24579	7.4%
b	24579	7.4%
W	12413	3.7%
-	12413	3.7%
l	12343	3.7%
Other values (7)	85973	25.9%

last_visit_time
Date

Distinct	30101
Distinct (%)	81.4%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Minimum	2025-10-26 00:00:00
Maximum	2025-10-26 23:59:59
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

days_since_last_login
Real number (ℝ)

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-41.915576

Minimum	-999
Maximum	26
Zeros	0
Zeros (%)	0.0%
Negative	1999
Negative (%)	5.4%
Memory size	289.1 KiB

Quantile statistics

Minimum	-999
5-th percentile	-999
Q1	8
median	12
Q3	16
95-th percentile	22
Maximum	26
Range	1025
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	228.8199
Coefficient of variation (CV)	-5.4590661
Kurtosis	13.545985
Mean	-41.915576
Median Absolute Deviation (MAD)	4
Skewness	-3.9413558
Sum	-1550541
Variance	52358.547
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
12	2380	6.4%
13	2373	6.4%
14	2307	6.2%
15	2278	6.2%
11	2262	6.1%
10	2091	5.7%
16	2068	5.6%
-999	1999	5.4%
9	1863	5.0%
17	1747	4.7%
Other values (17)	15624	42.2%

Value	Count	Frequency (%)
-999	1999	5.4%
1	328	0.9%
2	613	1.7%
3	852	2.3%
4	998	2.7%
5	1234	3.3%
6	1257	3.4%
7	1442	3.9%
8	1571	4.2%
9	1863	5.0%

Value	Count	Frequency (%)
26	82	0.2%
25	203	0.5%
24	471	1.3%
23	727	2.0%
22	895	2.4%
21	1015	2.7%
20	1184	3.2%
19	1308	3.5%
18	1444	3.9%
17	1747	4.7%

avg_time_spent
Real number (ℝ)

Distinct	25961
Distinct (%)	70.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	243.47233

Minimum	-2814.1091
Maximum	3235.5785
Zeros	0
Zeros (%)	0.0%
Negative	1719
Negative (%)	4.6%
Memory size	289.1 KiB

Quantile statistics

Minimum	-2814.1091
5-th percentile	30.15
Q1	60.1025
median	161.765
Q3	356.515
95-th percentile	1031.0767
Maximum	3235.5785
Range	6049.6876
Interquartile range (IQR)	296.4125

Descriptive statistics

Standard deviation	398.28915
Coefficient of variation (CV)	1.6358703
Kurtosis	5.0039153
Mean	243.47233
Median Absolute Deviation (MAD)	122.88
Skewness	0.53962402
Sum	9006528.6
Variance	158634.25
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34.1	21	0.1%
34.71	20	0.1%
33.68	20	0.1%
34.33	19	0.1%
31.49	18	< 0.1%
33.28	18	< 0.1%
32.91	18	< 0.1%
30.56	18	< 0.1%
33.71	18	< 0.1%
32.96	17	< 0.1%
Other values (25951)	36805	99.5%

Value	Count	Frequency (%)
-2814.10911	1	< 0.1%
-2281.236526	1	< 0.1%
-2096.580681	1	< 0.1%
-2093.121606	1	< 0.1%
-2034.80188	1	< 0.1%
-2012.267374	1	< 0.1%
-1960.479169	1	< 0.1%
-1941.035419	1	< 0.1%
-1918.486339	1	< 0.1%
-1913.405154	1	< 0.1%

Value	Count	Frequency (%)
3235.578521	1	< 0.1%
3040.41	1	< 0.1%
2899.66	1	< 0.1%
2861.23	1	< 0.1%
2770.56	1	< 0.1%
2766.75	1	< 0.1%
2747.89134	1	< 0.1%
2732.7	1	< 0.1%
2722.077794	1	< 0.1%
2705.756608	1	< 0.1%

avg_transaction_value
Real number (ℝ)

Distinct	36894
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29271.194

Minimum	800.46
Maximum	99914.05
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	289.1 KiB

Quantile statistics

Minimum	800.46
5-th percentile	3468.9665
Q1	14177.54
median	27554.485
Q3	40855.11
95-th percentile	67338.889
Maximum	99914.05
Range	99113.59
Interquartile range (IQR)	26677.57

Descriptive statistics

Standard deviation	19444.806
Coefficient of variation (CV)	0.66429836
Kurtosis	1.428287
Mean	29271.194
Median Absolute Deviation (MAD)	13336.775
Skewness	1.0110272
Sum	1.0828 × 10⁹
Variance	3.7810049 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14176.97	2	< 0.1%
7282.58	2	< 0.1%
30126.02	2	< 0.1%
21244.03	2	< 0.1%
23142.51	2	< 0.1%
35460.38	2	< 0.1%
9341.33	2	< 0.1%
34143.6	2	< 0.1%
3432.73	2	< 0.1%
6801.07	2	< 0.1%
Other values (36884)	36972	99.9%

Value	Count	Frequency (%)
800.46	1	< 0.1%
804.34	1	< 0.1%
806.22	1	< 0.1%
806.71	1	< 0.1%
813.82	1	< 0.1%
815.22	1	< 0.1%
821.83	1	< 0.1%
822.7	1	< 0.1%
823.49	1	< 0.1%
823.68	1	< 0.1%

Value	Count	Frequency (%)
99914.05	1	< 0.1%
99861.47	1	< 0.1%
99858.02	1	< 0.1%
99819.19	1	< 0.1%
99810.83	1	< 0.1%
99805.52	1	< 0.1%
99803.53	1	< 0.1%
99795.75	1	< 0.1%
99742.63	1	< 0.1%
99730.17	1	< 0.1%

avg_frequency_login_days
Text

Distinct	1654
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Length

Max length	21
Median length	4
Mean length	4.494215
Min length	3

Characters and Unicode

Total characters	166250
Distinct characters	15
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1623 ?
Unique (%)	4.4%

Sample

1st row	17.0
2nd row	10.0
3rd row	22.0
4th row	6.0
5th row	16.0

Value	Count	Frequency (%)
error	3522	9.5%
13.0	1394	3.8%
19.0	1365	3.7%
8.0	1361	3.7%
14.0	1355	3.7%
17.0	1349	3.6%
6.0	1336	3.6%
10.0	1334	3.6%
18.0	1331	3.6%
12.0	1327	3.6%
Other values (1644)	21318	57.6%

Most occurring characters

Value	Count	Frequency (%)
0	36699	22.1%
.	33470	20.1%
1	18719	11.3%
2	16061	9.7%
r	10566	6.4%
5	6508	3.9%
7	6331	3.8%
6	6312	3.8%
8	6269	3.8%
9	6258	3.8%
Other values (5)	19057	11.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	114487	68.9%
Other Punctuation	33470	20.1%
Lowercase Letter	14088	8.5%
Uppercase Letter	3522	2.1%
Dash Punctuation	683	0.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	36699	32.1%
1	18719	16.4%
2	16061	14.0%
5	6508	5.7%
7	6331	5.5%
6	6312	5.5%
8	6269	5.5%
9	6258	5.5%
3	5692	5.0%
4	5638	4.9%

Lowercase Letter

Value	Count	Frequency (%)
r	10566	75.0%
o	3522	25.0%

Other Punctuation

Value	Count	Frequency (%)
.	33470	100.0%

Uppercase Letter

Value	Count	Frequency (%)
E	3522	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	683	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	148640	89.4%
Latin	17610	10.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	36699	24.7%
.	33470	22.5%
1	18719	12.6%
2	16061	10.8%
5	6508	4.4%
7	6331	4.3%
6	6312	4.2%
8	6269	4.2%
9	6258	4.2%
3	5692	3.8%
Other values (2)	6321	4.3%

Latin

Value	Count	Frequency (%)
r	10566	60.0%
E	3522	20.0%
o	3522	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	166250	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	36699	22.1%
.	33470	20.1%
1	18719	11.3%
2	16061	9.7%
r	10566	6.4%
5	6508	3.9%
7	6331	3.8%
6	6312	3.8%
8	6269	3.8%
9	6258	3.8%
Other values (5)	19057	11.5%

points_in_wallet
Real number (ℝ)

High correlation

Distinct	23699
Distinct (%)	64.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	687.88161

Minimum	-760.66124
Maximum	2069.0698
Zeros	0
Zeros (%)	0.0%
Negative	136
Negative (%)	0.4%
Memory size	289.1 KiB

Quantile statistics

Minimum	-760.66124
5-th percentile	351.82615
Q1	624.35
median	697.62
Q3	757.0025
95-th percentile	1028.8753
Maximum	2069.0698
Range	2829.731
Interquartile range (IQR)	132.6525

Descriptive statistics

Standard deviation	184.83801
Coefficient of variation (CV)	0.26870614
Kurtosis	5.1849907
Mean	687.88161
Median Absolute Deviation (MAD)	65.685
Skewness	-0.10049675
Sum	25446117
Variance	34165.091
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
697.62	3446	9.3%
705.07	9	< 0.1%
780.92	8	< 0.1%
771.75	7	< 0.1%
710.69	7	< 0.1%
760.54	7	< 0.1%
620.57	6	< 0.1%
719.39	6	< 0.1%
783.42	6	< 0.1%
734.4	6	< 0.1%
Other values (23689)	33484	90.5%

Value	Count	Frequency (%)
-760.6612363	1	< 0.1%
-549.3574977	1	< 0.1%
-506.2567158	1	< 0.1%
-483.8564006	1	< 0.1%
-471.577009	1	< 0.1%
-469.0203988	1	< 0.1%
-445.2884572	1	< 0.1%
-424.6705248	1	< 0.1%
-412.4416878	1	< 0.1%
-405.2670355	1	< 0.1%

Value	Count	Frequency (%)
2069.069761	1	< 0.1%
1816.933696	1	< 0.1%
1780.720173	1	< 0.1%
1763.351594	1	< 0.1%
1759.002532	1	< 0.1%
1755.455512	1	< 0.1%
1755.094693	1	< 0.1%
1751.304195	1	< 0.1%
1750.611562	1	< 0.1%
1736.332594	1	< 0.1%

used_special_discount
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	36.3 KiB

True	20342
False	16650

Value	Count	Frequency (%)
True	20342	55.0%
False	16650	45.0%

offer_application_preference
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	36.3 KiB

True	20440
False	16552

Value	Count	Frequency (%)
True	20440	55.3%
False	16552	44.7%

past_complaint
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	36.3 KiB

False	18602
True	18390

Value	Count	Frequency (%)
False	18602	50.3%
True	18390	49.7%

complaint_status
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Not Applicable	18602
Unsolved	4644
Solved	4619
Solved in Follow-up	4577
No Information Available	4550

Length

Max length	24
Median length	14
Mean length	14.09648
Min length	6

Characters and Unicode

Total characters	521457
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Applicable
2nd row	Solved
3rd row	Solved in Follow-up
4th row	Unsolved
5th row	Solved

Common Values

Value	Count	Frequency (%)
Not Applicable	18602	50.3%
Unsolved	4644	12.6%
Solved	4619	12.5%
Solved in Follow-up	4577	12.4%
No Information Available	4550	12.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
not	18602	25.2%
applicable	18602	25.2%
solved	9196	12.5%
unsolved	4644	6.3%
in	4577	6.2%
follow-up	4577	6.2%
no	4550	6.2%
information	4550	6.2%
available	4550	6.2%

Most occurring characters

Value	Count	Frequency (%)
l	69298	13.3%
o	55246	10.6%
p	41781	8.0%
e	36992	7.1%
	36856	7.1%
i	32279	6.2%
a	32252	6.2%
N	23152	4.4%
t	23152	4.4%
A	23152	4.4%
Other values (16)	147297	28.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	410753	78.8%
Uppercase Letter	69271	13.3%
Space Separator	36856	7.1%
Dash Punctuation	4577	0.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	69298	16.9%
o	55246	13.4%
p	41781	10.2%
e	36992	9.0%
i	32279	7.9%
a	32252	7.9%
t	23152	5.6%
b	23152	5.6%
c	18602	4.5%
v	18390	4.5%
Other values (8)	59609	14.5%

Uppercase Letter

Value	Count	Frequency (%)
N	23152	33.4%
A	23152	33.4%
S	9196	13.3%
U	4644	6.7%
F	4577	6.6%
I	4550	6.6%

Space Separator

Value	Count	Frequency (%)
	36856	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4577	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	480024	92.1%
Common	41433	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	69298	14.4%
o	55246	11.5%
p	41781	8.7%
e	36992	7.7%
i	32279	6.7%
a	32252	6.7%
N	23152	4.8%
t	23152	4.8%
A	23152	4.8%
b	23152	4.8%
Other values (14)	119568	24.9%

Common

Value	Count	Frequency (%)
	36856	89.0%
-	4577	11.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	521457	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	69298	13.3%
o	55246	10.6%
p	41781	8.0%
e	36992	7.1%
	36856	7.1%
i	32279	6.2%
a	32252	6.2%
N	23152	4.4%
t	23152	4.4%
A	23152	4.4%
Other values (16)	147297	28.2%

feedback
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.1 KiB

Poor Product Quality	6350
No reason specified	6290
Too many ads	6279
Poor Website	6271
Poor Customer Service	6252
Other values (4)	5550

Length

Max length	24
Median length	21
Mean length	17.355455
Min length	12

Characters and Unicode

Total characters	642013
Distinct characters	31
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Products always in Stock
2nd row	Quality Customer Care
3rd row	Poor Website
4th row	Poor Website
5th row	Poor Website

Common Values

Value	Count	Frequency (%)
Poor Product Quality	6350	17.2%
No reason specified	6290	17.0%
Too many ads	6279	17.0%
Poor Website	6271	17.0%
Poor Customer Service	6252	16.9%
Reasonable Price	1417	3.8%
User Friendly Website	1391	3.8%
Products always in Stock	1382	3.7%
Quality Customer Care	1360	3.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
poor	18873	18.0%
quality	7710	7.4%
website	7662	7.3%
customer	7612	7.3%
product	6350	6.1%
reason	6290	6.0%
no	6290	6.0%
specified	6290	6.0%
too	6279	6.0%
many	6279	6.0%
Other values (11)	25035	23.9%

Most occurring characters

Value	Count	Frequency (%)
o	81027	12.6%
	67678	10.5%
e	62703	9.8%
r	52318	8.1%
s	39705	6.2%
i	38394	6.0%
a	33516	5.2%
t	32098	5.0%
P	28022	4.4%
c	23073	3.6%
Other values (21)	183479	28.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	497567	77.5%
Uppercase Letter	76768	12.0%
Space Separator	67678	10.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	81027	16.3%
e	62703	12.6%
r	52318	10.5%
s	39705	8.0%
i	38394	7.7%
a	33516	6.7%
t	32098	6.5%
c	23073	4.6%
u	23054	4.6%
d	21692	4.4%
Other values (10)	89987	18.1%

Uppercase Letter

Value	Count	Frequency (%)
P	28022	36.5%
C	8972	11.7%
Q	7710	10.0%
W	7662	10.0%
S	7634	9.9%
N	6290	8.2%
T	6279	8.2%
R	1417	1.8%
U	1391	1.8%
F	1391	1.8%

Space Separator

Value	Count	Frequency (%)
	67678	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	574335	89.5%
Common	67678	10.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	81027	14.1%
e	62703	10.9%
r	52318	9.1%
s	39705	6.9%
i	38394	6.7%
a	33516	5.8%
t	32098	5.6%
P	28022	4.9%
c	23073	4.0%
u	23054	4.0%
Other values (20)	160425	27.9%

Common

Value	Count	Frequency (%)
	67678	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	642013	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	81027	12.6%
	67678	10.5%
e	62703	9.8%
r	52318	8.1%
s	39705	6.2%
i	38394	6.0%
a	33516	5.2%
t	32098	5.0%
P	28022	4.4%
c	23073	3.6%
Other values (21)	183479	28.6%

churn_risk_score
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4633975

Minimum	-1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	1163
Negative (%)	3.1%
Memory size	289.1 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	3
median	4
Q3	5
95-th percentile	5
Maximum	5
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.4096609
Coefficient of variation (CV)	0.40701679
Kurtosis	1.299243
Mean	3.4633975
Median Absolute Deviation (MAD)	1
Skewness	-1.1143052
Sum	128118
Variance	1.9871439
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	10424	28.2%
4	10185	27.5%
5	9827	26.6%
2	2741	7.4%
1	2652	7.2%
-1	1163	3.1%

Value	Count	Frequency (%)
-1	1163	3.1%
1	2652	7.2%
2	2741	7.4%
3	10424	28.2%
4	10185	27.5%
5	9827	26.6%

Value	Count	Frequency (%)
5	9827	26.6%
4	10185	27.5%
3	10424	28.2%
2	2741	7.4%
1	2652	7.2%
-1	1163	3.1%

Interactions

Correlations

	age	avg_time_spent	avg_transaction_value	churn_risk_score	complaint_status	days_since_last_login	feedback	gender	internet_option	joined_through_referral	medium_of_operation	membership_category	offer_application_preference	past_complaint	points_in_wallet	preferred_offer_types	region_category	used_special_discount
age	1.000	0.003	-0.001	0.004	0.000	-0.003	0.006	0.000	0.014	0.003	0.008	0.000	0.000	0.012	-0.001	0.007	0.000	0.000
avg_time_spent	0.003	1.000	0.019	-0.029	0.002	-0.100	0.021	0.000	0.010	0.088	0.209	0.004	0.104	0.000	0.011	0.007	0.012	0.113
avg_transaction_value	-0.001	0.019	1.000	-0.201	0.000	-0.005	0.244	0.000	0.002	0.033	0.023	0.131	0.035	0.000	0.106	0.039	0.024	0.000
churn_risk_score	0.004	-0.029	-0.201	1.000	0.000	0.016	0.441	0.000	0.000	0.047	0.027	0.413	0.050	0.011	-0.548	0.064	0.034	0.006
complaint_status	0.000	0.002	0.000	0.000	1.000	0.013	0.000	0.000	0.005	0.005	0.000	0.000	0.011	1.000	0.000	0.007	0.000	0.004
days_since_last_login	-0.003	-0.100	-0.005	0.016	0.013	1.000	0.012	0.008	0.000	0.008	0.000	0.000	0.000	0.000	-0.002	0.004	0.000	0.000
feedback	0.006	0.021	0.244	0.441	0.000	0.012	1.000	0.003	0.005	0.047	0.028	0.188	0.049	0.010	0.083	0.064	0.033	0.008
gender	0.000	0.000	0.000	0.000	0.000	0.008	0.003	1.000	0.000	0.000	0.002	0.000	0.000	0.004	0.000	0.006	0.000	0.000
internet_option	0.014	0.010	0.002	0.000	0.005	0.000	0.005	0.000	1.000	0.004	0.000	0.003	0.000	0.000	0.000	0.000	0.000	0.000
joined_through_referral	0.003	0.088	0.033	0.047	0.005	0.008	0.047	0.000	0.004	1.000	0.044	0.022	0.021	0.000	0.006	0.000	0.000	0.019
medium_of_operation	0.008	0.209	0.023	0.027	0.000	0.000	0.028	0.002	0.000	0.044	1.000	0.013	0.049	0.005	0.000	0.000	0.000	0.063
membership_category	0.000	0.004	0.131	0.413	0.000	0.000	0.188	0.000	0.003	0.022	0.013	1.000	0.011	0.005	0.205	0.024	0.013	0.004
offer_application_preference	0.000	0.104	0.035	0.050	0.011	0.000	0.049	0.000	0.000	0.021	0.049	0.011	1.000	0.005	0.003	0.000	0.000	0.814
past_complaint	0.012	0.000	0.000	0.011	1.000	0.000	0.010	0.004	0.000	0.000	0.005	0.005	0.005	1.000	0.000	0.000	0.000	0.005
points_in_wallet	-0.001	0.011	0.106	-0.548	0.000	-0.002	0.083	0.000	0.000	0.006	0.000	0.205	0.003	0.000	1.000	0.011	0.006	0.010
preferred_offer_types	0.007	0.007	0.039	0.064	0.007	0.004	0.064	0.006	0.000	0.000	0.000	0.024	0.000	0.000	0.011	1.000	0.004	0.000
region_category	0.000	0.012	0.024	0.034	0.000	0.000	0.033	0.000	0.000	0.000	0.000	0.013	0.000	0.000	0.006	0.004	1.000	0.000
used_special_discount	0.000	0.113	0.000	0.006	0.004	0.000	0.008	0.000	0.000	0.019	0.063	0.004	0.814	0.005	0.010	0.000	0.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	customer_id	Name	age	gender	security_no	region_category	membership_category	joining_date	joined_through_referral	referral_id	preferred_offer_types	medium_of_operation	internet_option	last_visit_time	days_since_last_login	avg_time_spent	avg_transaction_value	avg_frequency_login_days	points_in_wallet	used_special_discount	offer_application_preference	past_complaint	complaint_status	feedback	churn_risk_score
0	fffe4300490044003600300030003800	Pattie Morrisey	18	F	XW0DQ7H	Village	Platinum Membership	2017-08-17	No	xxxxxxxx	Gift Vouchers/Coupons	?	Wi-Fi	16:08:02	17	300.63	53005.25	17.0	781.75	Yes	Yes	No	Not Applicable	Products always in Stock	2
1	fffe43004900440032003100300035003700	Traci Peery	32	F	5K0N3X1	City	Premium Membership	2017-08-28	?	CID21329	Gift Vouchers/Coupons	Desktop	Mobile_Data	12:38:13	16	306.34	12838.38	10.0	697.62	Yes	No	Yes	Solved	Quality Customer Care	1
2	fffe4300490044003100390032003600	Merideth Mcmeen	44	F	1F2TCL3	Town	No Membership	2016-11-11	Yes	CID12313	Gift Vouchers/Coupons	Desktop	Wi-Fi	22:53:21	14	516.16	21027.00	22.0	500.69	No	Yes	Yes	Solved in Follow-up	Poor Website	5
3	fffe43004900440036003000330031003600	Eufemia Cardwell	37	M	VJGJ33N	City	No Membership	2016-10-29	Yes	CID3793	Gift Vouchers/Coupons	Desktop	Mobile_Data	15:57:50	11	53.27	25239.56	6.0	567.66	No	Yes	Yes	Unsolved	Poor Website	5
4	fffe43004900440031003900350030003600	Meghan Kosak	31	F	SVZXCWB	City	No Membership	2017-09-12	No	xxxxxxxx	Credit/Debit Card Offers	Smartphone	Mobile_Data	15:46:44	20	113.13	24483.66	16.0	663.06	No	Yes	Yes	Solved	Poor Website	5
5	fffe43004900440036003300320035003300	Leslie Browder	13	M	PSG1LGF	City	Gold Membership	2016-01-08	No	xxxxxxxx	Gift Vouchers/Coupons	?	Wi-Fi	06:46:07	23	433.62	13884.77	24.0	722.27	Yes	No	Yes	Unsolved	No reason specified	3
6	fffe43004900440031003100360037003900	Bridget Balog	21	M	R3CX1EA	Town	Gold Membership	2015-03-19	Yes	CID24708	Gift Vouchers/Coupons	Desktop	Mobile_Data	11:40:04	10	55.38	8982.50	28.0	756.21	Yes	No	Yes	Solved in Follow-up	No reason specified	3
7	fffe4300490044003800300035003800	Herma Torgeson	42	M	4UJ1551	Town	No Membership	2016-07-12	?	CID56614	Credit/Debit Card Offers	Both	Fiber_Optic	07:52:43	19	429.11	44554.82	24.0	568.08	No	Yes	Yes	Unsolved	Poor Product Quality	5
8	fffe43004900440033003300330032003200	Pattie Helmers	44	M	0481QNQ	Village	Silver Membership	2016-12-14	No	xxxxxxxx	Without Offers	Smartphone	Fiber_Optic	06:50:10	15	191.07	18362.31	20.0	697.62	Yes	No	Yes	Solved in Follow-up	Poor Customer Service	3
9	fffe43004900440032003000340038003300	Shaquana Leech	45	F	ZHP4MCR	Town	No Membership	2016-11-30	No	xxxxxxxx	Gift Vouchers/Coupons	?	Wi-Fi	19:10:16	10	97.31	19244.16	28.0	706.23	No	Yes	Yes	No Information Available	Poor Customer Service	4

	customer_id	Name	age	gender	security_no	region_category	membership_category	joining_date	joined_through_referral	referral_id	preferred_offer_types	medium_of_operation	internet_option	last_visit_time	days_since_last_login	avg_time_spent	avg_transaction_value	avg_frequency_login_days	points_in_wallet	used_special_discount	offer_application_preference	past_complaint	complaint_status	feedback	churn_risk_score
36982	fffe43004900440033003600330033003800	Leslie Bruneau	45	F	I2TAL7N	Town	Premium Membership	2016-08-31	No	xxxxxxxx	Gift Vouchers/Coupons	?	Wi-Fi	08:30:41	10	34.930000	41558.93	19.0	703.030000	Yes	No	No	Not Applicable	Poor Product Quality	3
36983	fffe43004900440032003300370030003700	Faustina Balog	45	M	PU0XLQY	Town	Basic Membership	2016-08-30	Yes	CID45477	Without Offers	Smartphone	Wi-Fi	10:53:31	9	49.330000	45358.49	11.0	242.979625	Yes	No	No	Not Applicable	Poor Customer Service	5
36984	fffe43004900440035003800320035003300	Hilary Ortego	51	M	LM92BDS	Town	Gold Membership	2016-10-07	No	xxxxxxxx	Without Offers	Desktop	Fiber_Optic	15:41:36	24	312.330000	63446.71	2.0	778.700000	No	Yes	No	Not Applicable	Products always in Stock	1
36985	fffe4300490044003800310034003500	Dwain Cann	12	F	GWAHGJY	Village	Premium Membership	2016-10-25	No	xxxxxxxx	Gift Vouchers/Coupons	Desktop	Fiber_Optic	03:30:17	13	418.380000	56397.21	7.0	725.890000	Yes	Yes	Yes	Unsolved	Products always in Stock	2
36986	fffe43004900440034003900300036003500	Marlena Chastain	27	M	8X0LUUS	Town	Platinum Membership	2015-09-07	Yes	CID15800	Credit/Debit Card Offers	Desktop	Mobile_Data	05:29:19	13	135.830000	8225.68	16.0	748.570000	Yes	No	No	Not Applicable	No reason specified	3
36987	fffe43004900440035003500390036003100	Cuc Tarr	46	F	6F51HFO	Town	Basic Membership	2017-09-21	No	xxxxxxxx	Credit/Debit Card Offers	Desktop	Wi-Fi	04:14:05	2	-650.682759	27277.68	6.0	639.510000	No	Yes	Yes	No Information Available	No reason specified	4
36988	fffe43004900440033003500380036003600	Jenni Stronach	29	F	21KSM8Y	Town	Basic Membership	2016-06-27	No	xxxxxxxx	Without Offers	Smartphone	Wi-Fi	23:18:31	13	-638.123421	11069.71	28.0	527.990000	Yes	No	No	Not Applicable	Poor Customer Service	5
36989	fffe4300490044003500330034003100	Luciana Kinch	23	F	XK1IM9H	Town	Basic Membership	2016-09-11	Yes	CID3838	Gift Vouchers/Coupons	Desktop	Wi-Fi	03:50:25	12	154.940000	38127.56	Error	680.470000	No	Yes	Yes	Unsolved	Poor Website	4
36990	fffe43004900440031003200390039003000	Tawana Ardoin	53	M	K6VTP1Z	Village	Platinum Membership	2017-06-15	No	xxxxxxxx	Gift Vouchers/Coupons	Smartphone	Mobile_Data	09:50:03	15	482.610000	2378.86	20.0	197.264414	Yes	Yes	No	Not Applicable	No reason specified	3
36991	fffe43004900440033003600340034003200	Verlene Beaulieu	35	M	LBX0GLR	Town	Silver Membership	2015-10-23	No	xxxxxxxx	Gift Vouchers/Coupons	Desktop	Mobile_Data	01:39:52	15	79.180000	2189.68	Error	719.970000	Yes	No	No	Not Applicable	Quality Customer Care	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common